/* Dwarf_Load.sql */

insert into mountain (mountain_name,location)
	values ('Moria','Misty Mountains');

insert into mountain (mountain_name,location)
	values ('Erebor','Rhovanion');

insert into mountain (mountain_name,location)
	values ('Iron Hills','Rhovanion');

insert into dwarf (dwarf_name,born)
	values ('Durin',1731);

insert into dwarf (dwarf_name,born)
	values ('Nain',1832);

insert into dwarf (dwarf_name,born)
	values ('Thrain',1934);

insert into dwarf (dwarf_name,born)
	values ('Thorin',2035);

update mountain set king_id = 
	(select dwarf_id from dwarf where dwarf_name = 'Durin')
	where mountain_name = 'Moria';

update dwarf set home_id =
	(select mountain_id from mountain where mountain_name = 'Moria')
	where home_id is null;

insert into dwarf (dwarf_name,born)
	values ('Gloin',2136);

insert into dwarf (dwarf_name,born)
	values ('Oin',2238);

insert into dwarf (dwarf_name,born)
	values ('Dain',2440);

insert into dwarf (dwarf_name,born)
	values ('DainWife',2450);

update mountain set king_id = 
	(select dwarf_id from dwarf where dwarf_name = 'Dain')
	where mountain_name = 'Erebor';

update dwarf set home_id =
	(select mountain_id from mountain where mountain_name = 'Erebor')
	where home_id is null;

update dwarf set spouse_id = 
	(select dwarf_id from dwarf where dwarf_name = 'Dain')
	where dwarf_name = 'DainWife';

update dwarf set spouse_id = 
	(select dwarf_id from dwarf where dwarf_name = 'DainWife')
	where dwarf_name = 'Dain';

insert into visit(dwarf_id,mountain_id)
	select dwarf_id, home_id from dwarf;

insert into visit (dwarf_id, mountain_id)
	values (1,2);
insert into visit (dwarf_id, mountain_id)
	values (1,3);
insert into visit (dwarf_id, mountain_id)
	values (3,3);
insert into visit (dwarf_id, mountain_id)
	values (5,3);